excel中用VBA提取某一个单元格内包含某关键字符串的一行内容前的整数...答:Set Cell = Cells(Target.Cells(1, 1).Row, "A") TempStr = Left(Cell, InStr(1, Cell, Target) - 1) Target.Offset(0, 1) = Replace(Replace(Mid(TempStr, InStrRev(TempStr, Chr(10)), Len(TempStr)), "=", ""), " ", "") End IfEnd Sub ...